home *** CD-ROM | disk | FTP | other *** search
/ Programming Languages Suite / ProgramD2.iso / Visual Database / Visual dBase v5.5 / SAMPLES1.PAK / CONTACT.QBE < prev    next >
Text File  |  1995-07-18  |  430b  |  17 lines
  1. * dBASE Windows .QBE file 9
  2. CLOSE DATABASES
  3. SET EXACT ON
  4. SELECT 1
  5. USE COMPANY.DBF
  6. SELECT 2
  7. USE CONTACT.DBF ORDER TAG COMPCODE
  8. SELECT 1
  9. SET RELATION TO compcode INTO CONTACT
  10. SET FILTER TO FOUND(2)
  11. SET FIELDS TO COMPANY, STREET1, STREET2, CITY, STATE_PROV, ZIP_P_CODE, PHONE;
  12. , TYPE, COMPCODE, NOTES, YTD_SALES, ORD_REV, TERM_CLASS, CORP_OFF, SIC_CODE
  13. SELECT 2
  14. SET FIELDS TO COMPCODE, CONTACT, NOTES
  15. SELECT 1
  16. GO TOP
  17.